DataGrid Samples
Quickly populate DataGrids from workbooks without Excel
DataGrid Samples Workbooks are an excellent source of data for the built-in DataGrid, DataSet and DataTable components included in the Microsoft .NET Framework, as well as the many third party charting and other controls which accept a DataSet or DataTable. SpreadsheetGear for .NET makes it easy to populate a DataSet or DataTable from a workbook or worksheet range, as demonstrated by these samples.
Spreadsheet to DataGrid
Retrieve data from a workbook and display it in a DataGridView control.
Spreadsheet to DataGrid with Formats and Formulas
Insert data from a DataTable into a workbook, merging the data with formatting and formulas. The results are displayed in a DataGridView control.